<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `fanwe_supplier_location`;");
E_C("CREATE TABLE `fanwe_supplier_location` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `route` text NOT NULL,
  `address` text NOT NULL,
  `tel` varchar(255) NOT NULL,
  `contact` varchar(255) NOT NULL,
  `xpoint` varchar(255) NOT NULL,
  `ypoint` varchar(255) NOT NULL,
  `supplier_id` int(11) NOT NULL,
  `open_time` varchar(255) NOT NULL,
  `stop` varchar(255) NOT NULL,
  `brief` text NOT NULL,
  `description` text NOT NULL,
  `is_main` tinyint(1) NOT NULL,
  `api_address` text NOT NULL,
  `city_id` int(11) NOT NULL,
  `deal_cate_match` text NOT NULL,
  `deal_cate_match_row` text NOT NULL,
  `locate_match` text NOT NULL,
  `locate_match_row` text NOT NULL,
  `name_match` text NOT NULL,
  `name_match_row` text NOT NULL,
  `purpose_match` text NOT NULL,
  `purpose_match_row` text NOT NULL,
  `deal_cate_id` int(11) NOT NULL,
  `preview` varchar(255) NOT NULL,
  `is_recommend` tinyint(1) NOT NULL COMMENT '推荐的门店',
  `rec_brief` varchar(255) NOT NULL,
  `is_verify` tinyint(1) NOT NULL COMMENT '认证门店',
  `is_hot` tinyint(1) NOT NULL,
  `tags` varchar(255) NOT NULL,
  `tags_match` text NOT NULL,
  `tags_match_row` text NOT NULL,
  `avg_point` float(14,4) NOT NULL,
  `good_dp_count` int(11) NOT NULL,
  `bad_dp_count` int(11) NOT NULL,
  `common_dp_count` int(11) NOT NULL,
  `total_point` int(11) NOT NULL,
  `dp_count` int(11) NOT NULL,
  `imp_count` int(11) NOT NULL,
  `image_count` int(11) NOT NULL,
  `ref_avg_price` float(14,4) NOT NULL,
  `good_rate` float(14,4) NOT NULL,
  `common_rate` float(14,4) NOT NULL,
  `sms_content` varchar(255) NOT NULL DEFAULT '',
  `index_img` varchar(255) NOT NULL DEFAULT '',
  `tuan_count` int(11) NOT NULL,
  `event_count` int(11) NOT NULL,
  `youhui_count` int(11) NOT NULL,
  `daijin_count` int(11) NOT NULL,
  `seo_title` text NOT NULL,
  `seo_keyword` text NOT NULL,
  `seo_description` text NOT NULL,
  `is_effect` tinyint(1) NOT NULL,
  `biz_license` varchar(255) NOT NULL,
  `biz_other_license` varchar(255) NOT NULL,
  `new_dp_count` int(11) NOT NULL,
  `new_dp_count_time` int(11) NOT NULL,
  `shop_count` int(11) NOT NULL,
  `has_box` tinyint(1) NOT NULL,
  `open_up` tinyint(1) NOT NULL,
  `one_line_order` tinyint(1) NOT NULL DEFAULT '0',
  `hall` int(11) NOT NULL,
  `box` int(11) NOT NULL,
  `s_box` int(11) NOT NULL,
  `m_box` int(11) NOT NULL,
  `b_box` int(11) NOT NULL,
  `v_box` int(11) NOT NULL,
  `no_smoking` tinyint(1) NOT NULL,
  `menu_count` int(11) NOT NULL,
  `is_bank` tinyint(1) NOT NULL DEFAULT '0',
  `avg_price` tinyint(1) NOT NULL,
  `sort` int(11) NOT NULL,
  `deal_type` tinyint(1) NOT NULL,
  `takeaway` tinyint(4) NOT NULL,
  `takeaway_price` float(14,4) NOT NULL,
  `takeaway_nums` int(11) NOT NULL,
  `takeaway_zk` varchar(255) NOT NULL,
  `takeaway_cx` varchar(255) NOT NULL,
  `takeaway_time` int(11) NOT NULL,
  `takeaway_tel` varchar(100) NOT NULL,
  `online_info` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `city_id` (`city_id`),
  KEY `is_verify` (`is_verify`),
  KEY `is_effect` (`is_effect`),
  KEY `is_recommend` (`is_recommend`),
  KEY `avg_point` (`avg_point`),
  KEY `good_dp_count` (`good_dp_count`),
  KEY `bad_dp_count` (`bad_dp_count`),
  KEY `common_dp_count` (`common_dp_count`),
  KEY `total_point` (`total_point`),
  KEY `dp_count` (`dp_count`),
  KEY `good_rate` (`good_rate`),
  KEY `common_rate` (`common_rate`),
  KEY `tuan_count` (`tuan_count`),
  KEY `event_count` (`event_count`),
  KEY `youhui_count` (`youhui_count`),
  KEY `daijin_count` (`daijin_count`),
  KEY `new_dp_count` (`new_dp_count`),
  KEY `is_main` (`is_main`),
  KEY `supplier_id` (`supplier_id`) USING BTREE,
  KEY `search_idx1` (`city_id`,`is_recommend`,`is_effect`,`is_verify`) USING BTREE,
  KEY `search_idx2` (`city_id`,`avg_point`,`is_effect`) USING BTREE,
  KEY `search_idx3` (`supplier_id`,`is_main`) USING BTREE,
  KEY `search_idx4` (`city_id`,`deal_cate_id`,`is_verify`,`is_effect`,`is_recommend`) USING BTREE,
  KEY `search_idx5` (`city_id`,`deal_cate_id`,`dp_count`,`avg_point`,`ref_avg_price`,`is_effect`,`is_recommend`,`is_verify`) USING BTREE,
  KEY `search_idx6` (`good_rate`,`is_verify`,`is_effect`) USING BTREE,
  KEY `sort_default` (`is_recommend`,`is_verify`,`dp_count`) USING BTREE,
  KEY `ref_avg_price` (`ref_avg_price`),
  KEY `shop_count` (`shop_count`),
  KEY `avg_price` (`avg_price`),
  KEY `search_idx7` (`city_id`,`deal_cate_id`,`dp_count`,`avg_point`,`ref_avg_price`,`is_effect`,`is_recommend`,`is_verify`,`takeaway`) USING BTREE,
  FULLTEXT KEY `name_match` (`name_match`),
  FULLTEXT KEY `locate_match` (`locate_match`),
  FULLTEXT KEY `deal_cate_match` (`deal_cate_match`),
  FULLTEXT KEY `tags_match` (`tags_match`),
  FULLTEXT KEY `all_match` (`deal_cate_match`,`locate_match`,`name_match`,`tags_match`,`purpose_match`),
  FULLTEXT KEY `purpose_match` (`purpose_match`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8");
E_D("replace into `fanwe_supplier_location` values('1','商务布丁提供本程序','','安泰店：鼓楼区吉庇路39号（安泰楼后面，码头一号旁）','','','','','23','','','本程序由商务布丁shop103641321.taobao.com提供,更多极品商业源码,请联系旺旺：商务布丁','','1','','1','','','','','','','','','0','./public/attachment/201303/04/21/5134a8dab1a34.jpg','1','','1','1','','','','4.0000','1','0','0','4','1','0','0','0.0000','1.0000','0.0000','','./public/attachment/201303/04/21/5134a8c889908.jpg','4','0','0','3','','','','1','','','1','0','0','0','0','1','0','0','0','0','0','0','1','0','1','2','0','0','1','0.0000','0','','','0','','');");
E_D("replace into `fanwe_supplier_location` values('2','商务布丁提供本程序','18、52、62、65、72、75、108、117、134路省体育中心站路','福州鼓楼区五四北路330号省体市中心(近西二环路) ','888888','商务布丁','120.423531','36.066134','24','8:00-21:00','有，停车地址和收费仅供参考，以实际情况为准。','本程序由商务布丁shop103641321.taobao.com提供,更多极品商业源码,请联系旺旺：商务布丁','','1','','15','','','','','','','','','8','./public/attachment/201303/04/22/5134a95f14c48.jpg','1','本程序由商务布丁shop103641321.taobao.com提供,更多极品商业源码,请联系旺旺：商务布丁','1','1','','','','5.0000','3','0','0','15','3','0','0','0.0000','1.0000','0.0000','','./public/attachment/201303/04/22/5134a955d1e1b.jpg','0','0','0','0','','','','1','','','3','0','0','0','0','1','13','12','0','0','0','0','0','0','0','2','0','0','0','0.0000','0','','','0','','本程序由商务布丁shop103641321.taobao.com提供,更多极品商业源码,请联系旺旺：商务布丁');");
E_D("replace into `fanwe_supplier_location` values('3','老刘野生大鱼坊','','','','','','','25','','','本程序由盛世源码社区<a href=\"http://www.9upp.com|vip.9upp.com|www.9upp.com\">www.9upp.com|vip.9upp.com|www.9upp.com</a>提供,更多极品商业源码,就在盛世源码社区vip服务:vip.9upp.com<br />','','1','','1','','','','','ux32769ux21016,ux22823ux40060,ux37326ux29983,ux32769ux21016ux37326ux29983ux22823ux40060ux22346','老刘,大鱼,野生,老刘野生大鱼坊','','','0','./public/attachment/201303/04/22/5134aa302c504.jpg','1','','1','1','','','','3.0000','1','0','0','3','1','0','0','0.0000','1.0000','0.0000','','./public/attachment/201303/04/22/5134aa285bdad.jpg','0','0','0','0','','','','1','','','1','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0.0000','0','','','0','','');");
E_D("replace into `fanwe_supplier_location` values('4','闽粤汇','','','','','','','26','','','<center><div style=\"line-height:21px;\">资源提供：<a href=\"http://www.9upp.com/\" target=\"_blank\"><font color=\"red\">盛世源码社区</font></a><br />\r\n&nbsp;<a href=\"http://www.9upp.com/\" target=\"_blank\">盛世源码社区</a> | <a href=\"http://vip.9upp.com/\" target=\"_blank\">极品商业源码</a> | <a href=\"http://idc.9upp.com/\" target=\"_blank\">盛世源码社区空间、域名</a> | <a href=\"http://vip.9upp.com/templates/Korea/\" target=\"_blank\">90G韩国豪华商业模版</a> | <a href=\"http://tool.9upp.com/\" target=\"_blank\">站长工具箱</a><br />\r\n更多精品商业资源，就在<a href=\"http://www.9upp.com/\" target=\"_blank\">盛世源码社区</a></font></div>\r\n</center>','','1','','1','','','','','ux38397ux31908,ux38397ux31908ux27719','闽粤,闽粤汇','','','0','./public/attachment/201303/05/00/5134c70277bcd.jpg','1','','1','1','','','','0.0000','0','0','0','0','0','0','0','0.0000','0.0000','0.0000','','./public/attachment/201303/05/00/5134c6ed346be.jpg','0','0','0','0','','','','1','','','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0.0000','0','','','0','','');");
E_D("replace into `fanwe_supplier_location` values('5','食锦斋','','','','','','','27','','','<center><div style=\"line-height:21px;\">资源提供：<a href=\"http://www.9upp.com/\" target=\"_blank\"><font color=\"red\">盛世源码社区</font></a><br />\r\n&nbsp;<a href=\"http://www.9upp.com/\" target=\"_blank\">盛世源码社区</a> | <a href=\"http://vip.9upp.com/\" target=\"_blank\">极品商业源码</a> | <a href=\"http://idc.9upp.com/\" target=\"_blank\">盛世源码社区空间、域名</a> | <a href=\"http://vip.9upp.com/templates/Korea/\" target=\"_blank\">90G韩国豪华商业模版</a> | <a href=\"http://tool.9upp.com/\" target=\"_blank\">站长工具箱</a><br />\r\n更多精品商业资源，就在<a href=\"http://www.9upp.com/\" target=\"_blank\">盛世源码社区</a></font></div>\r\n</center>','','1','','1','','','','','ux38182ux25995,ux39135ux38182ux25995','锦斋,食锦斋','','','0','./public/attachment/201303/05/00/5134c71f268b5.jpg','1','','1','1','','','','0.0000','0','0','0','0','0','0','0','0.0000','0.0000','0.0000','','./public/attachment/201303/05/00/5134c7171c1b9.jpg','0','0','0','0','','','','1','','','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0.0000','0','','','0','','');");

require("../../inc/footer.php");
?>